class CreateRosters < ActiveRecord::Migration
  def self.up
    create_table "rosters" do |t|
      t.column "owner_jid", :string, :limit => 90, :default => "", :null => false
      t.column "jid",       :string, :limit => 90, :default => "", :null => false
      t.column "status",    :string, :limit => 20, :default => "", :null => false
      t.column "msg",       :text
      t.column "alias",     :string, :limit => 90
      t.column "prestype",  :string, :limit => 30, :default => "", :null => false
    end
  end
  
  def self.down
    drop_table :rosters
  end
end


